Edinburgh’s road network

Edinburgh’s control zones

Time series analysis

Mapping accidents with roads: 2013

##                    LAYER Accident_Index
## 1 20mph existing streets            111
## 2    20mph local streets            156
## 3     20mph main streets            388
## 4                  30mph            231
## 5                  40mph             92
## 6        50, 60 or 70mph              4
## 7        Part time 20mph              7
## 8            Trunk roads              3
##   Speed_limit Accident_Index
## 1          20             40
## 2          30            868
## 3          40             84

Mapping accidents with roads: 2014

##                    LAYER Accident_Index
## 1 20mph existing streets            308
## 2    20mph local streets            316
## 3     20mph main streets            778
## 4                  30mph            532
## 5                  40mph            136
## 6        50, 60 or 70mph             28
## 7        Part time 20mph             18
## 8            Trunk roads             10
##   Speed_limit Accident_Index
## 1          20             78
## 2          30           1910
## 3          40            138

Mapping accidents with roads: 2015

##                    LAYER Accident_Index
## 1 20mph existing streets            106
## 2    20mph local streets            156
## 3     20mph main streets            327
## 4                  30mph            254
## 5                  40mph             80
## 6        50, 60 or 70mph             12
## 7        Part time 20mph              6
## 8            Trunk roads              5
##   Speed_limit Accident_Index
## 1          20             34
## 2          30            832
## 3          40             80

Mapping accidents with roads: 2018

##                    LAYER Accident_Index
## 1 20mph existing streets             74
## 2    20mph local streets            102
## 3     20mph main streets            220
## 4                  30mph            175
## 5                  40mph             52
## 6        50, 60 or 70mph              6
## 7        Part time 20mph              9
## 8            Trunk roads              2
##   Speed_limit Accident_Index
## 1          20            351
## 2          30            230
## 3          40             59

Count pre 20mph

##                    LAYER Accident_Index
## 1 20mph existing streets            525
## 2    20mph local streets            628
## 3     20mph main streets           1493
## 4                  30mph           1017
## 5                  40mph            308
## 6        50, 60 or 70mph             44
## 7        Part time 20mph             31
## 8            Trunk roads             18
##   Speed_limit Accident_Index
## 1          20            152
## 2          30           3610
## 3          40            302

Count post 20mph

##                    LAYER Accident_Index
## 1 20mph existing streets             74
## 2    20mph local streets            102
## 3     20mph main streets            220
## 4                  30mph            175
## 5                  40mph             52
## 6        50, 60 or 70mph              6
## 7        Part time 20mph              9
## 8            Trunk roads              2
##   Speed_limit Accident_Index
## 1          20            351
## 2          30            230
## 3          40             59

Output column: Layer

##   Accident_Index Speed_limit                  LAYER
## 1  2014950003991          30 20mph existing streets
## 2  2014950003991          30 20mph existing streets
## 3  2018950000480          30 20mph existing streets
## 4  2015950005695          30 20mph existing streets
## 5  2013950004051          20 20mph existing streets
## 6  2015950004165          30 20mph existing streets

Mapping accidents with zones: 2013

Mapping accidents with zones: 2014

Mapping accidents with zones: 2015

Mapping accidents with zones: 2018

Output column: Implementation Zone

##   Accident_Index Speed_limit ImplementationZone
## 1  2013950000001          30                  1
## 2  2013950000002          30                  2
## 3  2013950000003          30                  2
## 4  2013950000007          30                  1
## 5  2013950000010          30                  4
## 6  2013950000030          30                  2